create table if not exists d_rnt_rm_device_d_#{PARTITION_DATE}
 (
device_id    varchar(40) ,
collector_id    varchar(64) ,
agent_id     varchar(40) ,
sys_name     varchar(128) ,
ip_addr      varchar(20) ,
mac_addr     varchar(20) ,
netmask    varchar(20) ,
gateway    varchar(20) ,
district    varchar(20) ,
province    varchar(20) ,
city    varchar(20) ,
serial_number    varchar(60) ,
sys_location    varchar(255) ,
sys_descr    varchar(1024) ,
sys_oid    varchar(255) ,
sys_contact    varchar(128) ,
sys_uptime    varchar(32) ,
sys_version    varchar(255) ,
if_number    bigint ,
software_name    varchar(64) ,
software_version    varchar(20) ,
last_timestamp    datetime ,
alias      varchar(128) ,
project_status    varchar(32) ,
service_system_name    varchar(255) ,
vendor_device_type    varchar(32) ,
assigned_location    varchar(255) ,
device_level    varchar(25) ,
objseverity    double(38,0) ,
capacity_alert    bigint ,
collect_status    bigint ,
ping_status    bigint ,
parent_device_id    varchar(40) ,
update_sysname    bigint ,
zg_device_id    varchar(64) ,
zg_device_name    varchar(64) ,
zg_device_department    varchar(64) ,
ipv6_addr    varchar(128) ,
prefix_len    bigint ,
create_time    datetime 
)   compress(5, 5)  nolock ;